﻿CREATE TABLE [dbo].[Product]
(
	[Id] uniqueidentifier NOT NULL,
	[Name] nvarchar (100)  NOT NULL,
	[Title] nvarchar (100)  NULL,
	[ShortDescription] nvarchar (1000)  NULL,
	[LongDescription] nvarchar (max)  NULL,
	[Keywords] nvarchar (1000)  NULL,
	[DiscountPercent] decimal (3, 2) NOT NULL,
	[DiscountAmount] money NOT NULL,
	[HandlingCharge] money NOT NULL,
	[Price] money NOT NULL,
	[QuantityAvailable] int NOT NULL,
	[Weight] decimal (9, 2) NOT NULL
)


